package com.five.community.mapper;
import com.five.community.bean.Repair;
import com.five.community.bean.vo.RepairVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
@Mapper
public interface RepairMapper {
    //    查询所有报修表信息
    List<Repair> selectAll() throws Exception;
    //    根据id查询信息
    Repair selectById(long id) throws Exception;
    //    根据报修人员查询信息
    List<Repair> selectByName(String name) throws Exception;
    // 最终查询
    List<RepairVo> selectAllF() throws Exception;
    //根据name最终查询
    List<RepairVo> selectByNameF(String name) throws Exception;
    //插入报修数据
    void insert(Repair repair) throws Exception;
    //编辑修改报修数据
    void update(Repair repair) throws Exception;
    //删除报修数据根据ID
    void delete(long id) throws Exception;
}
